home *** CD-ROM | disk | FTP | other *** search
/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 311 < prev    next >
Unknown  |  1998-01-30  |  608 b 
open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text


This file was not able to be converted.
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
100% file data default


hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 43 41 53 |CHILD UP|DATE CAS|
|00000010| 43 41 44 45 00 20 20 2f | 2a 20 45 52 77 69 6e 20 |CADE.  /|* ERwin |
|00000020| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00000030| 65 20 2a 2f 0d 0a 20 20 | 2f 2a 20 25 50 61 72 65 |e */..  |/* %Pare|
|00000040| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00000050| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 55 |Child ON| CHILD U|
|00000060| 50 44 41 54 45 20 43 41 | 53 43 41 44 45 20 2a 2f |PDATE CA|SCADE */|
|00000070| 0d 0a 20 20 69 66 0d 0a | 20 20 20 20 2f 2a 20 25 |..  if..|    /* %|
|00000080| 25 43 68 69 6c 64 46 4b | 28 22 20 6f 72 22 2c 75 |%ChildFK|(" or",u|
|00000090| 70 64 61 74 65 29 20 2a | 2f 0d 0a 20 20 20 20 25 |pdate) *|/..    %|
|000000a0| 43 68 69 6c 64 46 4b 28 | 22 20 6f 72 22 2c 75 70 |ChildFK(|" or",up|
|000000b0| 64 61 74 65 29 0d 0a 20 | 20 62 65 67 69 6e 0d 0a |date).. | begin..|
|000000c0| 20 20 20 20 69 6e 73 65 | 72 74 20 25 50 61 72 65 |    inse|rt %Pare|
|000000d0| 6e 74 20 28 25 50 61 72 | 65 6e 74 50 4b 28 22 2c |nt (%Par|entPK(",|
|000000e0| 22 2c 29 29 0d 0a 20 20 | 20 20 20 20 73 65 6c 65 |",))..  |    sele|
|000000f0| 63 74 20 25 43 68 69 6c | 64 46 4b 28 22 2c 22 2c |ct %Chil|dFK(",",|
|00000100| 29 0d 0a 20 20 20 20 20 | 20 66 72 6f 6d 20 20 20 |)..     | from   |
|00000110| 69 6e 73 65 72 74 65 64 | 0d 0a 20 20 20 20 20 20 |inserted|..      |
|00000120| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 2f |where.. |       /|
|00000130| 2a 20 25 25 4e 6f 74 6e | 75 6c 6c 46 4b 28 69 6e |* %%Notn|ullFK(in|
|00000140| 73 65 72 74 65 64 2c 22 | 20 69 73 20 6e 6f 74 20 |serted,"| is not |
|00000150| 6e 75 6c 6c 20 61 6e 64 | 22 29 20 2a 2f 0d 0a 20 |null and|") */.. |
|00000160| 20 20 20 20 20 20 20 25 | 4e 6f 74 6e 75 6c 6c 46 |       %|NotnullF|
|00000170| 4b 28 69 6e 73 65 72 74 | 65 64 2c 22 20 69 73 20 |K(insert|ed," is |
|00000180| 6e 6f 74 20 6e 75 6c 6c | 20 61 6e 64 22 29 0d 0a |not null| and")..|
|00000190| 20 20 20 20 20 20 20 20 | 6e 6f 74 20 65 78 69 73 |        |not exis|
|000001a0| 74 73 20 28 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |ts (..  |        |
|000001b0| 73 65 6c 65 63 74 20 2a | 20 66 72 6f 6d 20 25 50 |select *| from %P|
|000001c0| 61 72 65 6e 74 0d 0a 20 | 20 20 20 20 20 20 20 20 |arent.. |        |
|000001d0| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|000001e0| 20 20 20 20 2f 2a 20 25 | 25 4a 6f 69 6e 46 4b 50 |    /* %|%JoinFKP|
|000001f0| 4b 28 69 6e 73 65 72 74 | 65 64 2c 25 50 61 72 65 |K(insert|ed,%Pare|
|00000200| 6e 74 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |nt," = "|," and")|
|00000210| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 | */..   |        |
|00000220| 20 25 4a 6f 69 6e 46 4b | 50 4b 28 69 6e 73 65 72 | %JoinFK|PK(inser|
|00000230| 74 65 64 2c 25 50 61 72 | 65 6e 74 2c 22 20 3d 20 |ted,%Par|ent," = |
|00000240| 22 2c 22 20 61 6e 64 22 | 29 0d 0a 20 20 20 20 20 |"," and"|)..     |
|00000250| 20 20 20 29 0d 0a 20 20 | 65 6e 64 0d 0a 00 1d 27 |   )..  |end....'|
+--------+-------------------------+-------------------------+--------+--------+